← Dashboard

Vivedis Engine Databasestructuur

content_engines

🔑 id INTEGER
name TEXT
description TEXT
version TEXT
status TEXT

niches

🔑 id INTEGER
name TEXT
description TEXT

products

🔑 id INTEGER
name TEXT
niche_id INTEGER
price_amazon REAL
price_reference REAL
status TEXT
topic_id INTEGER

sources

🔑 id INTEGER
product_id INTEGER
type TEXT
url TEXT
snippet TEXT

content_drafts

🔑 id INTEGER
product_id INTEGER
engine_name TEXT
raw_pulp TEXT
humanized TEXT
final_edited TEXT
status TEXT
content_type TEXT
topic_id INTEGER

engine_steps

🔑 id INTEGER
engine_name TEXT
step_number INTEGER
name TEXT
prompt_template TEXT
description TEXT
input_description TEXT
output_description TEXT

topics

🔑 id INTEGER
niche_id INTEGER
name TEXT
market_data TEXT
social_pain TEXT
expert_kader TEXT
status TEXT